package com.thermofisher.dsc.amanda.common.excel.mapper;

import com.thermofisher.dsc.amanda.common.excel.model.*;

import java.util.List;

import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * Created by wenjie.yang on 4/3/2019.
 */
@Repository
public interface ExcelCacheMapper{

  void insertEoneCustomerCacheList(List<E1Customer> e1Customers);

  void insertITSCARCacheList(List<ITSCARCache> itscrCaches);

  void insertIventoryCacheList(List<InventoryExcel> iventoryCaches);

  void insertSaleCustomerCacheList(List<SaleCustomer> saleCustomers);

  void insertSkuPriceCacheList(List<Map> skuPrices);

    /**
     * EXEC refresh_cache_table
     *     #{tableTarget},
     *     #{tableSource},
     *     #{keyWord}
     * @param tableTarget
     * @param tableSource
     * @param keyWord
     */
  void refreshTable(@Param("tableTarget") String tableTarget,@Param("tableSource")  String tableSource,@Param("keyWord")  String keyWord);


}

